package com.erpoa.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.HashMap;
import java.util.List;
import java.util.Map;


/**
 * @description:
 * @author: jamin.chen
 * @createDate: 2020/7/16 10:42
 * @version: 1.0
 */
@Mapper
public interface PingzhiMapper {

    @Select(" select ${sequence}.nextval  as sequence from dual ")
    String getSequence(@Param("sequence") String sequence);


    List<HashMap> selectDataWithfmachinecode(@Param("ffactorycode") String ffactorycode,@Param("fmachinecode") String fmachinecode,@Param("fplanbegindate")String fplanbegindate,
                                             @Param("fplanenddate")String fplanenddate);


    void createSequence(@Param("sequence") String sequence);

    @Update( " DROP SEQUENCE ${sequence} " )
    void dropSequence(@Param("sequence") String sequence);

    @Select(" select * from tc_pgen_file where tc_pgen01= #{hrno}  ")
    List<Map<String,Object>> selecttcpgenbyhrno(@Param("hrno") String hrno);


    HashMap testCallProduce();
}
